IF OBJECT_ID('ssf.gbl_get_variable_value') IS NOT NULL
	DROP FUNCTION ssf.gbl_get_variable_value
GO

CREATE FUNCTION ssf.gbl_get_variable_value (
	@variable_name NVARCHAR(128)
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
	RETURN (
		SELECT variable_value
		FROM ssf.gbl_variable WITH (NOLOCK)
		WHERE variable_name = @variable_name
	)
END
GO
